package com.yuxinmuyu.sports_management.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yuxinmuyu.sports_management.bean.entiy.SportsProject;
import com.yuxinmuyu.sports_management.bean.response.ClassResponse;
import com.yuxinmuyu.sports_management.bean.response.DeptResponse;
import com.yuxinmuyu.sports_management.bean.response.MajorResponse;
import com.yuxinmuyu.sports_management.bean.response.YearTermResponse;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

public interface SportsProjectMapper extends BaseMapper<SportsProject> {
    Page<SportsProject> getPage(Page<SportsProject> page, @Param("yearTermID") String yearTermID, @Param("sportsName") String sportsName);

    //int addProject(@Param("yearTermID")String yearTermID, @Param("sportsName")String sportsName, @Param("sportsMemo")String sportsMemo, @Param("lastDate")Date lastDate, @Param("operator")String operator);


    int deleteProject(String sportsName);

    int updateProject(String yearTermID, String sportsName, String sportsMemo, Date lastDate, String operator);

    List<YearTermResponse> getSelectList();

    List<DeptResponse> getDept();

    List<MajorResponse> getMajor(@Param("deptID") String deptID);

    List<ClassResponse> getSClass(@Param("majorID")String majorID);
}
